package com.doyens.mapper;

import com.doyens.pojo.Interviewer;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface InterviewerMapper {

    @Select("select name from interviewer where id in (select interviewerId from app_inter where applicantId=#{id})")
    List<Interviewer> findById(Integer id);

    @Select("select id,name from interviewer order by id")
    List<Interviewer> findAll();
}
